package com.roger.myHome.mapper;

import com.roger.myHome.entity.BloodSugarCurveData;
import com.roger.myHome.entity.ColumnData;
import com.roger.myHome.entity.qto.AvgExpenseQry;
import com.roger.myHome.entity.qto.TotalExpenseReq;
import com.roger.myHome.entity.vo.BloodSugarDetailData;
import com.roger.myHome.entity.vo.BloodSugarExceptionCurveData;
import com.roger.myHome.entity.vo.BloodSugarOrderByTime;
import com.roger.myHome.entity.vo.OneDayBloodGlucose;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.math.BigDecimal;
import java.util.List;

@Repository
public interface ReportMapper {
    List<BloodSugarCurveData> selectBloodSugarCurveReport(@Param("today") String today);

    List<BloodSugarExceptionCurveData> selectBloodSugarExceptionCurveReport(@Param("today") String today);

    List<ColumnData> selectExpenseByYear(TotalExpenseReq req);

    //?????
    Float selectBloodSugarAvg();

    BigDecimal getAvgExpense(AvgExpenseQry qry );

    List<BloodSugarOrderByTime> selectBloodSugarOrderByTime();

    List<OneDayBloodGlucose> listOneDayBloodGlucose();

    List<BloodSugarDetailData> selectBloodSugarDetailReport(@Param("today") String today);
}
